Sets an object array into a specified range of cells.
Syntax
'Declaration
Public Overloads Sub SetArray( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal (,) As Object, _
ByVal As Boolean, _
ByVal As ReferenceStyle _
)
'Usage
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim column As Integer
Dim value() As Object
Dim formula As Boolean
Dim referenceStyle As ReferenceStyle
instance.SetArray(row, column, value, formula, referenceStyle)
public void SetArray(
int ,
int column,
object[,] ,
bool ,
ReferenceStyle
)
Parameters
- row
- Row index of the start of the range of cells
- column
- Column index of the start of the range of cells
- value
- Two-dimensional object array[row,column] that contains the values
- formula
- If true, set formulas; otherwise, set values.
- referenceStyle
- The reference style of formulas
See Also